Release 10.1A: OpenEdge Development:
Progress Dynamics Administration

Configuring OpenEdge DataServer for Oracle

This section provides an example of setting up the connection with the OpenEdge Oracle® DataServer. You must supply the following connection parameters when you set up the connection to the schema holder database:

-db Progress_schema_holder_name -H host -S service -N TCP -db Oracle_db_name -ld same_Oracle_name -dt ORACLE -U "name/password@Oracle_instance" -H broker_host -S broker_service

You first supply the startup parameters for the schema holder database (Progress_schema_holder_name, etc.). The remaining parameters are used to start the DataServer connection to the non-OpenEdge database (Oracle_db_name, etc.).

The following example shows how this information is stored in the icfconfig.xml configuration file:

- <service> <cServiceType>Database</cServiceType> <cServiceName>ORA</cServiceName> <cPhysicalService>ORAn</cPhysicalService> <cConnectParams>-db sh_oratest -N TCP -H client_system -S demo_svc1     -db ora_db -ld ora_db -dt ORACLE -U "icftest/icftest@test821"     -H server_system -S demo_svc2</cConnectParams> <lDefaultService>no</lDefaultService> <lCanRunLocal>yes</lCanRunLocal> <iStartOrder>0</iStartOrder> </service>

Some important points:

For Oracle, the database type is always ORA.
For the Oracle connection, you must use double quotes around the user name and password. If double quotes are not used, Progress Dynamics might incorrectly parse the connection string.
The -ld and -dt parameters are optional.
If the schema holder is on the same machine as the client, then the -H and -S parameters for the schema holder are optional.
In this example, the second set of -H and -S parameters specify the location of the database broker. If the database broker is located on a different machine than where the client is running, you must specify the -H and -S parameters.